Excel question, part 2

[HarryCaray]

I have a column of cells that are in the format

6/13/2007 12:37:37 AM


I would like to add 2 days to each entry in the column, so the above cell would read

6/15/2007 12:37:37 AM


I'm usually good with adding dates and times and stuff, but can't figure this one out. Help would be greatly appreciated.

 

[HarryCaray]

Never mind, got it. You need to format the next column over as the same MM/DD/YYYY HH:MM:SS format, and put in formula =A2+day(2)